﻿CREATE TABLE [dbo].[PropunereAngajareCheltuialaDetaliu] (
    [IDPACDetaliu] INT             IDENTITY (1, 1) NOT NULL,
    [IDPac]        INT             NOT NULL,
    [IDJurnal]     INT             NOT NULL,
    [ArtAl]        VARCHAR (40)    NOT NULL,
    [Suma]         DECIMAL (18, 2) NOT NULL,
    [CredBugAprob] DECIMAL (18, 2) NULL,
    [CredBugAngaj] DECIMAL (18, 2) NULL,
    [Clasif]       VARCHAR (100)   NULL,
    CONSTRAINT [PK_PropunereAngajareCheltuialaDetaliu] PRIMARY KEY CLUSTERED ([IDPACDetaliu] ASC),
    CONSTRAINT [FK_PropunereAngajareCheltuialaDetaliu_Jurnale] FOREIGN KEY ([IDJurnal]) REFERENCES [dbo].[Jurnale] ([IDJurnal]),
    CONSTRAINT [FK_PropunereAngajareCheltuialaDetaliu_PropunereAngajareCheltuiala] FOREIGN KEY ([IDPac]) REFERENCES [dbo].[PropunereAngajareCheltuiala] ([IDPAC])
);

